﻿CREATE TABLE [dbo].[PunctLucru] (
    [IDPunctLucru]    INT          IDENTITY (1, 1) NOT NULL,
    [IDClient]        INT          NOT NULL,
    [Denumire]        VARCHAR (50) NOT NULL,
    [Judet]           VARCHAR (50) CONSTRAINT [DF_PunctLucru_Judet] DEFAULT ('') NOT NULL,
    [Sector]          SMALLINT     CONSTRAINT [DF_PunctLucru_Sector] DEFAULT ((0)) NOT NULL,
    [Localitate]      VARCHAR (30) CONSTRAINT [DF_PunctLucru_Localitate] DEFAULT ('') NOT NULL,
    [Strada]          VARCHAR (50) CONSTRAINT [DF_PunctLucru_Strada] DEFAULT ('') NOT NULL,
    [Numar]           VARCHAR (50) CONSTRAINT [DF_PunctLucru_Numar] DEFAULT ('') NOT NULL,
    [PersoanaContact] VARCHAR (50) CONSTRAINT [DF_PunctLucru_PersoanaContact] DEFAULT ('') NOT NULL,
    [CodUnitate]      SMALLINT     CONSTRAINT [DF_PunctLucru_CodUnitate] DEFAULT ((0)) NOT NULL,
    CONSTRAINT [PK_PunctLucru] PRIMARY KEY CLUSTERED ([IDPunctLucru] ASC)
);

